﻿<%@ Page Title="" Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="frmPlanilla2.aspx.cs" Inherits="frmPlanilla2" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style1
        {
            width: 100%;
            height: 546px;
                 }
        
        .style3
        {
            font-weight: normal;
        }
        .style27
        {
            height: 44px;
            width: 367px;
        }
        .style28
        {
            height: 1px;
            width: 367px;
        }
        .style31
        {
            width: 344px;
            height: 44px;
        }
        .style32
        {
            height: 1px;
            width: 344px;
        }
        .style33
        {
            width: 344px;
        }
        .style35
        {
            height: 18px;
            width: 367px;
        }
        .style37
        {
            height: 18px;
            width: 344px;
        }
        .style38
        {
            height: 18px;
            width: 343px;
        }
        .style39
        {
            height: 1px;
            width: 343px;
        }
        .style40
        {
            width: 343px;
            height: 44px;
        }
        .style41
        {
            width: 343px;
        }
        .style42
        {
            width: 367px;
        }
        
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
<h4>Menu</h4>
        <br>
        <p>
        <a href="frmEmpresa.aspx">Empresa</a>
        <br>
        <a href="frmListaDeEstablecimientos.aspx">Establecimientos</a>
        <br>
        <a href="frmContacto.aspx">Contactos</a>
        <br>
        <a href="frmEmpleados.aspx">Empleados</a>
        <br>
        </p>
</asp:Content>
<asp:Content ID="Content3" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table class="style1">
         <tr> <td bgcolor="#3399FF" class="style35" style="border-style: ridge" >
                <strong>DATOS DE EMPRESA:<br />
                <br />
                </strong>
         </td >
          <td class="style38" bgcolor="#3399FF" style="border-style: ridge" >
                <strong>DATOS DE ESTABLECIMIENTO:<br />
                <br />
                </strong></td >
          <td class="style37" bgcolor="#3399FF" style="border-style: ridge" >
                <strong>
                DATOS DEL DIRECTOR TECNICO:<br />
                <br />
                </strong></td >
          </tr>
           <tr> <td class="style28" >
                
         </td >
          <td class="style39">
               </td >
          <td class="style32"  >
                </td >
          </tr>
           <tr> <td class="style27" style="border: thin outset #FFFFFF;" >
                
                Razon Social: 
                <asp:Label ID="Lrazon" runat="server" Font-Bold="True" 
                    Width="278px" BorderColor="Black" ForeColor="#003366"></asp:Label>
                
         </td >
          <td class="style40" style="border: thin outset #FFFFFF;" >
               Nombre:
                <asp:Label ID="LnombreEst" runat="server" Font-Bold="True" 
                    Width="285px" ForeColor="#003366"></asp:Label>
               </td >
          <td class="style31" style="border: thin outset #FFFFFF;"  >
                Empleado:
                <asp:DropDownList ID="DropDownList1" runat="server" 
                    DataSourceID="SqlDataSource1" DataTextField="apellido" DataValueField="legajo" 
                    Height="29px" Width="155px" BackColor="#DDEDEE">
                </asp:DropDownList>
                <asp:Button ID="Button2" runat="server" CssClass="style10" Height="29px" 
                    onclick="Button2_Click" Text="Seleccionar" Width="104px" />
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Nombre Comercial:&nbsp;
                <asp:Label ID="Lnombre" runat="server" Font-Bold="True" 
                    Width="243px" BorderColor="Black" ForeColor="#003366"></asp:Label>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Numero de RNE:&nbsp;
                <asp:Label ID="LRNE" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Nombre:
                <asp:Label ID="Label25" runat="server" Font-Bold="True" 
                    Width="200px" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                CUIT:
                <asp:Label ID="Lcuit" runat="server" Font-Bold="True" 
                    Width="200px" BorderColor="Black" ForeColor="#003366"></asp:Label>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Telefono:
                <asp:Label ID="LtelefonoEst" runat="server" Font-Bold="True" Width="150px" 
                    ForeColor="#003366"></asp:Label>
&nbsp;&nbsp; 
                </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Apellido:
                <asp:Label ID="Label26" runat="server" Font-Bold="True" 
                    Width="200px" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Telefono:
                <asp:Label ID="Ltelefono" runat="server" Font-Bold="True" 
                    Width="150px" BorderColor="Black" ForeColor="#003366"></asp:Label>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                EMail:
                <asp:Label ID="LmailEst" runat="server" Font-Bold="True" 
                    Width="180px" ForeColor="#003366"></asp:Label>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Legajo:
                <asp:Label ID="Label27" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; DNI:
                <asp:Label ID="Label37" runat="server" Font-Bold="True" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Calle:
                <asp:Label ID="Lcalle" runat="server" Font-Bold="True" 
                    Width="161px" BorderColor="Black" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp;&nbsp; Nº:
                <asp:Label ID="Lnumero" runat="server" Font-Bold="True" 
                    Width="50px" BorderColor="Black" ForeColor="#003366"></asp:Label>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Calle:
                <asp:Label ID="LcalleEst" runat="server" Font-Bold="True" 
                    Width="154px" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp;&nbsp; Nº
                <asp:Label ID="LnumeroEst" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Cargo:
                <asp:Label ID="Label28" runat="server" Font-Bold="True" 
                    Width="100px" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp;&nbsp;
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Piso:
                <asp:Label ID="Lpiso" runat="server" Font-Bold="True" 
                    Width="50px" BorderColor="Black" ForeColor="#003366"></asp:Label>
&nbsp; Dpto.:
                <asp:Label ID="Ldpto" runat="server" Font-Bold="True" 
                    Width="50px" BorderColor="Black" ForeColor="#003366"></asp:Label>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Piso:
                <asp:Label ID="LpisoEst" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
&nbsp; Dpto.:
                <asp:Label ID="LdptoEst" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Telefono:&nbsp;
                <asp:Label ID="Label29" runat="server" Font-Bold="True" 
                    Width="100px" ForeColor="#003366"></asp:Label>
                &nbsp;</td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Barrio:
                <asp:Label ID="Lbarrio" runat="server" Font-Bold="True" 
                    Width="92px" BorderColor="Black" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp;Localidad:&nbsp;
                <asp:Label ID="Llocalidad" runat="server" Font-Bold="True" 
                    Width="89px" BorderColor="Black" ForeColor="#003366"></asp:Label>
               </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Barrio:
                <asp:Label ID="LbarrioEst" runat="server" Font-Bold="True" 
                    Width="83px" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp;Localidad:&nbsp;
                <asp:Label ID="LlocalidadEst" runat="server" Font-Bold="True" Width="100px" 
                    ForeColor="#003366"></asp:Label>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                EMail:&nbsp;
                <asp:Label ID="Label30" runat="server" Font-Bold="True" 
                    Width="150px" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Cod. Postal:&nbsp;
                <asp:Label ID="Lcodigo" runat="server" Font-Bold="True" 
                    Width="100px" BorderColor="Black" ForeColor="#003366"></asp:Label>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Cod. Postal:&nbsp;
                <asp:Label ID="LcodigoEst" runat="server" Font-Bold="True" 
                    Width="100px" ForeColor="#003366"></asp:Label>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Calle:
                <asp:Label ID="Label31" runat="server" Font-Bold="True" 
                    Width="200px" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp;&nbsp; Nº:
                <asp:Label ID="Label32" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Piso:
                <asp:Label ID="Label33" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
&nbsp; Dpto.:
                <asp:Label ID="Label34" runat="server" Font-Bold="True" 
                    Width="50px" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Forma Juridica:
                <asp:TextBox ID="TextBox1" runat="server" CssClass="style10" Width="248px" 
                    Height="27px" BackColor="#DDEDEE"></asp:TextBox>
                <br />
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Expediente Nº: 
                <asp:TextBox ID="TextBox4" runat="server" Width="216px" Height="27px" 
                    BackColor="#DDEDEE"></asp:TextBox>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
               Barrio:
                <asp:Label ID="Label35" runat="server" Font-Bold="True" 
                    Width="100px" ForeColor="#003366"></asp:Label>
&nbsp;&nbsp; Localidad:&nbsp;
                <asp:Label ID="Label36" runat="server" Font-Bold="True" 
                    Width="100px" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Nº Ingresos Brutos:
                <asp:TextBox ID="TextBox2" runat="server" CssClass="style10" Width="223px" 
                    Height="27px" BackColor="#DDEDEE"></asp:TextBox>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Nº Habilitacion MAGyA:
                <asp:TextBox ID="TextBox5" runat="server" Width="170px" Height="27px" 
                    BackColor="#DDEDEE"></asp:TextBox>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Cod. Postal:
                <asp:Label ID="Label38" runat="server" Font-Bold="True" ForeColor="#003366"></asp:Label>
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
                Representante:
                <asp:TextBox ID="TextBox3" runat="server" Width="250px" Height="27px" 
                    BackColor="#DDEDEE"></asp:TextBox>
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Nº Habilitacion SENASA:
                <asp:TextBox ID="TextBox6" runat="server" Width="163px" Height="27px" 
                    BackColor="#DDEDEE"></asp:TextBox>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                </td >
          </tr>
          </tr>
           <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Rubros Autorizados:
                <asp:TextBox ID="TextBox7" runat="server" Height="43px" TextMode="MultiLine" 
                    Width="304px" BackColor="#DDEDEE"></asp:TextBox>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                Profesion:<strong>
                 <asp:TextBox ID="TextBox9" runat="server" Width="237px" Height="26px" 
                    BackColor="#DDEDEE"></asp:TextBox>
                <br />
                </strong>Matricula:
                <strong>
                <asp:TextBox ID="TextBox10" runat="server" Width="239px" Height="27px" 
                    BackColor="#DDEDEE"></asp:TextBox>
                </strong>
                </td >
          </tr>
          <tr> <td class="style42" style="border: thin outset #FFFFFF;" >
                
         </td >
          <td class="style41" style="border: thin outset #FFFFFF;" >
                Dias y Horarios de Trabajo:<br />
                <asp:TextBox ID="TextBox8" runat="server" TextMode="MultiLine" Width="306px" 
                    BackColor="#DDEDEE"></asp:TextBox>
               </td >
          <td class="style33" style="border: thin outset #FFFFFF;"  >
                </td >
          </tr>
          <tr> <td class="style42" style="border-style: outset" >
                
         </td >
          <td class="style41" style="border-style: outset" >
               </td >
          <td class="style33" style="border-style: outset"  >
                </td >
          </tr>
          <tr> <td class="style42" >
                
                <strong>
                <asp:Button ID="Button1" runat="server" Height="28px" Text="Imprimir Planilla Nº2" 
                    Width="156px" onclick="Button1_Click1" />
                </strong>
                
         </td >
          <td class="style41" >
               </td >
          <td class="style33"  >
                </td >
          </tr>
          <tr> <td class="style42" >
                
         </td >
          <td class="style41" >
               </td >
          <td class="style33"  >
                </td >
          </tr>

        
        <tr>
            <td class="style42">
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                    SelectCommand="SELECT T_Empleado.legajo, T_Empleado.nombre, T_Empleado.apellido, T_Cargo.descripcionCargo, T_Localidad.nombreLocalidad, T_Barrio.nombreBarrio, T_Empleado.numDocumento, T_Empleado.dirCorreo, T_Empleado.numTelefono, T_Empleado.calle, T_Empleado.numeroCalle, T_Empleado.piso, T_Empleado.departamento FROM T_Empleado INNER JOIN T_Barrio ON T_Empleado.idBarrio = T_Barrio.idBarrio INNER JOIN T_Cargo ON T_Empleado.idCargo = T_Cargo.idCargo INNER JOIN T_Localidad ON T_Empleado.idLocalidad = T_Localidad.idLocalidad
">
                </asp:SqlDataSource>
                <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
                    ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
                    
                    SelectCommand="SELECT T_Empleado.legajo, T_Empleado.nombre, T_Empleado.apellido, T_Cargo.descripcionCargo, T_Localidad.nombreLocalidad, T_Barrio.nombreBarrio, T_Empleado.numDocumento, T_Empleado.dirCorreo, T_Empleado.numTelefono, T_Empleado.calle, T_Empleado.numeroCalle, T_Empleado.piso, T_Empleado.departamento, T_Empleado.codPostal FROM T_Empleado INNER JOIN T_Barrio ON T_Empleado.idBarrio = T_Barrio.idBarrio INNER JOIN T_Cargo ON T_Empleado.idCargo = T_Cargo.idCargo INNER JOIN T_Localidad ON T_Empleado.idLocalidad = T_Localidad.idLocalidad WHERE (T_Empleado.legajo = @legajo)">
                    <SelectParameters>
                        <asp:Parameter Name="legajo" />
                    </SelectParameters>
                </asp:SqlDataSource>
                <br />
            </td>
           
        </tr>
    </table>
</asp:Content>

